/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : 172.16.29.228
172.16.29.228
 Source Database       : eladmin

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : utf-8

 Date: 07/29/2020 21:27:00 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `code_column_config`
-- ----------------------------
DROP TABLE IF EXISTS `code_column_config`;
CREATE TABLE `code_column_config` (
  `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `column_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `column_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dict_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `extra` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `form_show` bit(1) DEFAULT NULL,
  `form_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `key_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `list_show` bit(1) DEFAULT NULL,
  `not_null` bit(1) DEFAULT NULL,
  `query_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_annotation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`column_id`) USING BTREE,
  KEY `idx_table_name` (`table_name`)
) ENGINE=InnoDB AUTO_INCREMENT=176 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='代码生成字段信息存储';

-- ----------------------------
--  Records of `code_column_config`
-- ----------------------------
BEGIN;
INSERT INTO `code_column_config` VALUES ('1', 'gen_test', 'id', 'int', null, 'auto_increment', b'0', null, 'PRI', b'0', b'1', null, 'ID', null), ('2', 'gen_test', 'sex', 'int', null, '', b'1', null, '', b'1', b'0', 'NotNull', '性别', null), ('3', 'gen_test', 'create_time', 'datetime', null, '', b'0', null, '', b'1', b'0', 'BetWeen', '', null), ('139', 'quartz_log', 'id', 'bigint', null, 'auto_increment', b'1', null, 'PRI', b'1', b'0', null, '', null), ('140', 'quartz_log', 'baen_name', 'varchar', null, '', b'1', null, '', b'1', b'0', null, '', null), ('141', 'quartz_log', 'create_time', 'datetime', null, '', b'1', null, '', b'1', b'0', null, '', null), ('142', 'quartz_log', 'cron_expression', 'varchar', null, '', b'1', null, '', b'1', b'0', null, '', null), ('143', 'quartz_log', 'exception_detail', 'text', null, '', b'1', null, '', b'1', b'0', null, '', null), ('144', 'quartz_log', 'is_success', 'bit', null, '', b'1', null, '', b'1', b'0', null, '', null), ('145', 'quartz_log', 'job_name', 'varchar', null, '', b'1', null, '', b'1', b'0', null, '', null), ('146', 'quartz_log', 'method_name', 'varchar', null, '', b'1', null, '', b'1', b'0', null, '', null), ('147', 'quartz_log', 'params', 'varchar', null, '', b'1', null, '', b'1', b'0', null, '', null), ('148', 'quartz_log', 'time', 'bigint', null, '', b'1', null, '', b'1', b'0', null, '', null), ('149', 'quartz_log', 'result', 'varchar', null, '', b'1', null, '', b'1', b'0', null, '', null), ('150', 'order_detail', 'id', 'bigint', null, 'auto_increment', b'1', null, 'PRI', b'1', b'0', null, '主键', null), ('151', 'order_detail', 'master_id', 'bigint', null, '', b'1', null, '', b'1', b'0', '=', '订单主表ID', null), ('152', 'order_detail', 'model', 'varchar', null, '', b'1', null, '', b'1', b'0', null, '型号', null), ('153', 'order_detail', 'color', 'varchar', null, '', b'1', null, '', b'1', b'0', null, '颜色', null), ('154', 'order_detail', 'size', 'char', null, '', b'1', null, '', b'1', b'0', null, '尺码', null), ('155', 'order_detail', 'style', 'varchar', null, '', b'1', null, '', b'1', b'0', null, '男女款', null), ('156', 'order_detail', 'quantity', 'tinyint', null, '', b'1', null, '', b'1', b'0', null, '件数', null), ('157', 'order_detail', 'unit_price', 'double', null, '', b'1', null, '', b'1', b'0', null, '单价', null), ('158', 'order_detail', 'total_price', 'double', null, '', b'1', null, '', b'1', b'0', null, '总价', null), ('159', 'stock', 'id', 'bigint', null, 'auto_increment', b'1', null, 'PRI', b'1', b'0', null, '主键', null), ('160', 'stock', 'model', 'varchar', null, '', b'1', 'Select', '', b'1', b'0', '=', '型号', null), ('161', 'stock', 'color', 'varchar', null, '', b'1', 'Select', '', b'1', b'0', '=', '颜色', null), ('162', 'stock', 'size', 'char', null, '', b'1', 'Select', '', b'1', b'0', '=', '尺码', null), ('163', 'stock', 'style', 'varchar', null, '', b'1', 'Select', '', b'1', b'0', '=', '男女款', null), ('164', 'stock', 'total_quantity', 'tinyint', null, '', b'1', null, '', b'1', b'0', null, '件数', null), ('165', 'stock', 'sold_quantity', 'tinyint', null, '', b'1', null, '', b'1', b'0', null, '卖出的数量', null), ('166', 'order_master', 'id', 'bigint', null, 'auto_increment', b'1', null, 'PRI', b'1', b'0', null, '主键', null), ('167', 'order_master', 'order_date', 'date', null, '', b'1', null, '', b'1', b'0', '=', '下单时间', null), ('168', 'order_master', 'quantity', 'tinyint', null, '', b'1', null, '', b'1', b'0', null, '件数', null), ('169', 'order_master', 'total_price', 'double', null, '', b'1', null, '', b'1', b'0', null, '总价', null), ('170', 'order_master', 'postage', 'double', null, '', b'1', null, '', b'1', b'0', null, '邮费', null), ('171', 'order_master', 'postage_direct', 'double', null, '', b'1', null, '', b'1', b'0', '=', '0:不需快递；1：寄方支付；2：收方支付', null), ('172', 'order_master', 'express', 'varchar', null, '', b'1', null, '', b'1', b'0', null, '物流公司', null), ('173', 'order_master', 'express_number', 'varchar', null, '', b'1', null, '', b'1', b'0', null, '物流单号', null), ('174', 'order_master', 'send_off', 'tinyint', null, '', b'1', null, '', b'1', b'0', '=', '是否发货', null), ('175', 'order_master', 'memo', 'varchar', null, '', b'1', null, '', b'1', b'0', null, '备注', null);
COMMIT;

-- ----------------------------
--  Table structure for `code_gen_config`
-- ----------------------------
DROP TABLE IF EXISTS `code_gen_config`;
CREATE TABLE `code_gen_config` (
  `config_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '表名',
  `author` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '作者',
  `cover` bit(1) DEFAULT NULL COMMENT '是否覆盖',
  `module_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模块名称',
  `pack` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '至于哪个包下',
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '前端代码生成的路径',
  `api_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '前端Api文件路径',
  `prefix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '表前缀',
  `api_alias` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '接口名称',
  PRIMARY KEY (`config_id`) USING BTREE,
  KEY `idx_table_name` (`table_name`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='代码生成器配置';

-- ----------------------------
--  Records of `code_gen_config`
-- ----------------------------
BEGIN;
INSERT INTO `code_gen_config` VALUES ('3', 'gen_test', 'Zheng Jie', b'1', 'eladmin-system', 'me.zhengjie.gen', 'E:\\workspace\\me\\front\\eladmin-web\\src\\views\\gen', 'E:\\workspace\\me\\front\\eladmin-web\\src\\api', null, '测试生成'), ('8', 'stock', 'tec', b'0', 'eladmin-system', 'com.tec.modules.order', 'order/stock', 'order/stock/', null, '库存一览'), ('9', 'order_master', 'tec', b'0', 'eladmin-system', 'com.tec.modules.order', 'order/bizOrder', 'order/bizOrder/', null, '销售订单'), ('10', 'order_detail', 'tec', b'0', 'eladmin-system', 'com.tec.modules.order', 'order/orderDetail', 'order/orderDetail/', null, '订单明细');
COMMIT;

-- ----------------------------
--  Table structure for `gen_test`
-- ----------------------------
DROP TABLE IF EXISTS `gen_test`;
CREATE TABLE `gen_test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sex` int(255) DEFAULT NULL COMMENT '性别',
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='代码生成测试';

-- ----------------------------
--  Table structure for `mnt_app`
-- ----------------------------
DROP TABLE IF EXISTS `mnt_app`;
CREATE TABLE `mnt_app` (
  `app_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用名称',
  `upload_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '上传目录',
  `deploy_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '部署路径',
  `backup_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备份路径',
  `port` int(255) DEFAULT NULL COMMENT '应用端口',
  `start_script` varchar(4000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '启动脚本',
  `deploy_script` varchar(4000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '部署脚本',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`app_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='应用管理';

-- ----------------------------
--  Records of `mnt_app`
-- ----------------------------
BEGIN;
INSERT INTO `mnt_app` VALUES ('1', 'eladmin-monitor-2.4.jar', '/opt/upload', '/opt/monitor', '/opt/backup', '8777', 'cd /opt/monitor\nnohup java -jar eladmin-monitor-2.4.jar >nohup.out 2>&1 &', 'mv -f /opt/upload/eladmin-monitor-2.4.jar /opt/monitor\ncd /opt/monitor\nnohup java -jar eladmin-monitor-2.4.jar >nohup.out 2>&1 &', '2019-11-24 20:52:59', null, null, null), ('2', 'eladmin-system-2.3.jar', '/opt/upload', '/opt/eladmin', '/opt/backup/eladmin', '8000', 'cd /opt/eladmin\nnohup java -jar eladmin-system-2.3.jar --spring.profiles.active=prod >nohup.out 2>&1 &', 'mv -f /opt/upload/eladmin-system-2.3.jar /opt/eladmin/\ncd /opt/eladmin\nnohup java -jar eladmin-system-2.3.jar --spring.profiles.active=prod >nohup.out 2>&1 &', '2019-12-21 16:39:57', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `mnt_database`
-- ----------------------------
DROP TABLE IF EXISTS `mnt_database`;
CREATE TABLE `mnt_database` (
  `db_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
  `jdbc_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'jdbc连接',
  `user_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '账号',
  `pwd` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码',
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`db_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='数据库管理';

-- ----------------------------
--  Records of `mnt_database`
-- ----------------------------
BEGIN;
INSERT INTO `mnt_database` VALUES ('c4109eefc5724c65857ca9dd2690e0dd', 'eladmin', 'jdbc:mysql://localhost:3306/eladmin?serverTimezone=Asia/Shanghai', 'root', '123456', '2019-12-21 21:11:17', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `mnt_deploy`
-- ----------------------------
DROP TABLE IF EXISTS `mnt_deploy`;
CREATE TABLE `mnt_deploy` (
  `deploy_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `app_id` bigint(20) DEFAULT NULL COMMENT '应用编号',
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`deploy_id`) USING BTREE,
  KEY `FK6sy157pseoxx4fmcqr1vnvvhy` (`app_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='部署管理';

-- ----------------------------
--  Records of `mnt_deploy`
-- ----------------------------
BEGIN;
INSERT INTO `mnt_deploy` VALUES ('3', '1', '2019-12-21 15:53:06', null, null, null), ('6', '2', '2019-12-21 17:09:02', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `mnt_deploy_history`
-- ----------------------------
DROP TABLE IF EXISTS `mnt_deploy_history`;
CREATE TABLE `mnt_deploy_history` (
  `history_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ID',
  `app_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '应用名称',
  `deploy_date` datetime NOT NULL COMMENT '部署日期',
  `deploy_user` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '部署用户',
  `ip` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '服务器IP',
  `deploy_id` bigint(20) DEFAULT NULL COMMENT '部署编号',
  PRIMARY KEY (`history_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='部署历史管理';

-- ----------------------------
--  Records of `mnt_deploy_history`
-- ----------------------------
BEGIN;
INSERT INTO `mnt_deploy_history` VALUES ('4ee0edd1f3b648a396280a542d72c121', 'eladmin-monitor-2.4.jar', '2019-12-22 13:06:07', 'admin', '132.232.129.20', '3'), ('4fd432a128c947ccae55316b3d5dcd7b', 'eladmin-monitor-2.4.jar', '2019-12-22 13:49:09', 'admin', '132.232.129.20', '3'), ('cfda21f48da341b396657af94554c890', 'eladmin-monitor-2.4.jar', '2019-12-22 13:08:22', 'admin', '132.232.129.20', '3');
COMMIT;

-- ----------------------------
--  Table structure for `mnt_deploy_server`
-- ----------------------------
DROP TABLE IF EXISTS `mnt_deploy_server`;
CREATE TABLE `mnt_deploy_server` (
  `deploy_id` bigint(20) NOT NULL,
  `server_id` bigint(20) NOT NULL,
  PRIMARY KEY (`deploy_id`,`server_id`) USING BTREE,
  KEY `FKeaaha7jew9a02b3bk9ghols53` (`server_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='应用与服务器关联';

-- ----------------------------
--  Records of `mnt_deploy_server`
-- ----------------------------
BEGIN;
INSERT INTO `mnt_deploy_server` VALUES ('3', '1'), ('6', '1');
COMMIT;

-- ----------------------------
--  Table structure for `mnt_server`
-- ----------------------------
DROP TABLE IF EXISTS `mnt_server`;
CREATE TABLE `mnt_server` (
  `server_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `account` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '账号',
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'IP地址',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
  `port` int(11) DEFAULT NULL COMMENT '端口',
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`server_id`) USING BTREE,
  KEY `idx_ip` (`ip`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='服务器管理';

-- ----------------------------
--  Records of `mnt_server`
-- ----------------------------
BEGIN;
INSERT INTO `mnt_server` VALUES ('1', 'root', '132.232.129.20', '腾讯云', 'Dqjdda1996.', '8013', '2019-11-24 20:35:02', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `order_detail`
-- ----------------------------
DROP TABLE IF EXISTS `order_detail`;
CREATE TABLE `order_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `master_id` bigint(20) DEFAULT NULL COMMENT '订单主表ID',
  `model` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '型号',
  `color` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '颜色',
  `size` char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '尺码',
  `style` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '男女款',
  `quantity` tinyint(4) DEFAULT NULL COMMENT '件数',
  `unit_price` double DEFAULT NULL COMMENT '单价',
  `total_price` double DEFAULT NULL COMMENT '总价',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='订单明细表';

-- ----------------------------
--  Records of `order_detail`
-- ----------------------------
BEGIN;
INSERT INTO `order_detail` VALUES ('1', '1', '', '', '', '', '4', '25', '100'), ('2', '2', 'ATSM353-1紧身型', '蓝色', 'L', '男款', '1', '50', '50'), ('3', '2', 'ATSM353-1紧身型', '蓝色', '3XL', '男款', '1', '50', '50'), ('4', '3', 'ATSM353-1紧身型', '蓝色', 'L', '男款', '8', '40', '320'), ('5', '3', 'ATSM246-1', '粉色', 'L', '女款', '2', '40', '80'), ('6', '4', 'ATSM353-1紧身型', '蓝色', 'L', '男款', '1', '50', '50'), ('7', '5', 'ATSM353-1紧身型', '蓝色', 'L', '男款', '1', '45', '45');
COMMIT;

-- ----------------------------
--  Table structure for `order_master`
-- ----------------------------
DROP TABLE IF EXISTS `order_master`;
CREATE TABLE `order_master` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `order_date` date DEFAULT NULL COMMENT '下单时间',
  `quantity` tinyint(4) DEFAULT NULL COMMENT '件数',
  `total_price` double DEFAULT NULL COMMENT '总价',
  `postage` double DEFAULT NULL COMMENT '邮费',
  `postage_direct` double DEFAULT '1' COMMENT '0:不需快递；1：寄方支付；2：收方支付',
  `express` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '物流公司',
  `express_number` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '物流单号',
  `send_off` tinyint(1) DEFAULT NULL COMMENT '是否发货',
  `memo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='订单主表';

-- ----------------------------
--  Records of `order_master`
-- ----------------------------
BEGIN;
INSERT INTO `order_master` VALUES ('1', '2020-05-02', '4', '100', '0', '0', null, null, '1', '雪山寺内部销售4件'), ('2', '2020-05-21', '2', '100', '13', '1', '京东物流', 'JDX001753350001', '1', '哈尔滨买家下单购买，电话确认尺码颜色时，加购一件，微信转账。'), ('3', '2020-05-24', '10', '400', '13', '1', '京东物流', 'JDX001762663352', '1', '哈尔滨买家重复购买。'), ('4', '2020-05-26', '1', '50', '9', '1', '京东物流', 'JDX001772273543', '1', '临沂买家下单购买。'), ('5', '2020-07-23', '1', '45', '14', '1', '京东物流', 'JDX002190245659', '1', '云南买家下单购买。');
COMMIT;

-- ----------------------------
--  Table structure for `stock`
-- ----------------------------
DROP TABLE IF EXISTS `stock`;
CREATE TABLE `stock` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `model` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '型号',
  `color` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '颜色',
  `size` char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '尺码',
  `style` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '男女款',
  `total_quantity` tinyint(4) DEFAULT NULL COMMENT '件数',
  `sold_quantity` tinyint(4) DEFAULT NULL COMMENT '卖出的数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='商品库存';

-- ----------------------------
--  Records of `stock`
-- ----------------------------
BEGIN;
INSERT INTO `stock` VALUES ('1', 'ATSM353-1紧身型', '蓝色', '3XL', '男款', '14', '1'), ('2', 'ATSM353-1紧身型', '蓝色', '2XL', '男款', '5', null), ('3', 'ATSM353-1紧身型', '蓝色', 'L', '男款', '27', '11'), ('4', 'ATSM353-1紧身型', '蓝色', 'M', '男款', '17', null), ('5', 'ATSM353-1', '蓝色', 'S', '男款', '4', null), ('6', 'ATSM246-1', '粉色', '3XL', '女款', '2', null), ('7', 'ATSM246-1', '粉色', 'L', '女款', '15', '2'), ('8', 'ATSM246-1紧身型', '粉色', 'M', '女款', '8', null), ('9', 'ATSM246-1', '粉色', 'S', '女款', '7', null), ('10', '运动啦啦队服', '浅蓝色', 'L', '女款', '1', null), ('11', '运动啦啦队服', '浅蓝色', 'M', '女款', '5', null), ('12', '运动短裤', '粉色', 'M', '女款', '2', null), ('13', '运动短裤', '黑色', 'L', '男款', '1', null), ('14', '背心', '粉色', 'M', '女款', '3', null), ('15', '运动T恤', '黄绿色', '3XL', '男款', '1', null), ('16', 'POLO衫', '浅蓝色', 'L', '男款', '4', null), ('17', 'POLO衫', '红色', 'XL', '男款', '1', null), ('18', 'POLO衫', '白色', 'XL', '男款', '5', null), ('19', '运动裤', '黑色', '3XL', '男款', '1', null);
COMMIT;

-- ----------------------------
--  Table structure for `sys_dept`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
  `pid` bigint(20) DEFAULT NULL,
  `enabled` bit(1) NOT NULL COMMENT '状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `dept_sort` int(5) DEFAULT '999' COMMENT '排序',
  `sub_count` int(5) DEFAULT '0' COMMENT '子部门数目',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dept_id`) USING BTREE,
  KEY `idx_pid` (`pid`),
  KEY `inx_pid` (`pid`),
  KEY `inx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='部门';

-- ----------------------------
--  Records of `sys_dept`
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES ('1', 'TEC云', null, b'1', '2019-03-01 12:07:37', '999', '3', null, null, null), ('2', '研发部', '1', b'1', '2019-03-25 09:15:32', '999', '0', null, null, null), ('3', '测试部', '1', b'1', '2019-03-25 09:52:18', '999', '0', null, null, null), ('4', '运维部', '1', b'1', '2019-03-25 09:20:44', '999', '0', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `sys_dict`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字典名称',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dict_id`) USING BTREE,
  KEY `idx_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='数据字典';

-- ----------------------------
--  Records of `sys_dict`
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` VALUES ('1', 'user_status', '用户状态', '2019-10-27 20:31:36', null, null, null), ('2', 'dept_status', '部门状态', '2019-10-27 20:31:36', null, null, null), ('3', 'job_status', '岗位状态', '2019-10-27 20:31:36', null, null, null), ('4', 'size', '尺码', '2020-07-29 00:24:54', null, null, null), ('5', 'style', '男女款', '2020-07-29 00:38:40', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `sys_dict_detail`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_detail`;
CREATE TABLE `sys_dict_detail` (
  `detail_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字典标签',
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字典值',
  `dict_sort` int(5) DEFAULT NULL COMMENT '排序',
  `dict_id` bigint(11) DEFAULT NULL COMMENT '字典id',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`detail_id`) USING BTREE,
  KEY `FK5tpkputc6d9nboxojdbgnpmyb` (`dict_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='数据字典详情';

-- ----------------------------
--  Records of `sys_dict_detail`
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_detail` VALUES ('1', '激活', 'true', '1', '1', '2019-10-27 20:31:36', null, null, null), ('2', '禁用', 'false', '2', '1', null, null, null, null), ('3', '启用', 'true', '1', '2', null, null, null, null), ('4', '停用', 'false', '2', '2', '2019-10-27 20:31:36', null, null, null), ('5', '启用', 'true', '1', '3', null, null, null, null), ('6', '停用', 'false', '2', '3', '2019-10-27 20:31:36', null, null, null), ('7', '3XL', '3XL', '7', '4', '2020-07-29 00:25:19', null, null, null), ('8', '2XL', '2XL', '6', '4', '2020-07-29 00:25:29', null, null, null), ('9', 'XL', 'XL', '5', '4', '2020-07-29 00:25:44', null, null, null), ('10', 'L', 'L', '4', '4', '2020-07-29 00:25:49', null, null, null), ('11', 'M', 'M', '3', '4', '2020-07-29 00:25:54', null, null, null), ('12', 'S', 'S', '2', '4', '2020-07-29 00:26:04', null, null, null), ('13', 'XS', 'XS', '1', '4', '2020-07-29 00:26:09', null, null, null), ('14', '男款', '男款', '1', '5', '2020-07-29 00:38:49', null, null, null), ('15', '女款', '女款', '2', '5', '2020-07-29 00:38:58', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `sys_job`
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '岗位名称',
  `enabled` bit(1) NOT NULL COMMENT '岗位状态',
  `job_sort` int(5) DEFAULT NULL COMMENT '排序',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`job_id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`),
  KEY `inx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='岗位';

-- ----------------------------
--  Records of `sys_job`
-- ----------------------------
BEGIN;
INSERT INTO `sys_job` VALUES ('1', '全栈开发', b'1', '2', '2019-03-31 13:39:30', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `sys_log`
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `create_time` datetime DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exception_detail` text COLLATE utf8mb4_unicode_ci,
  `log_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `params` text COLLATE utf8mb4_unicode_ci,
  `request_ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time` bigint(20) DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`log_id`) USING BTREE,
  KEY `inx_log_type` (`log_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统日志';

-- ----------------------------
--  Table structure for `sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `i_frame` bit(1) DEFAULT NULL COMMENT '是否外链',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单标题',
  `component` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '组件',
  `pid` bigint(20) DEFAULT NULL,
  `menu_sort` int(5) DEFAULT NULL COMMENT '排序',
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图标',
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '链接地址',
  `cache` bit(1) DEFAULT b'0' COMMENT '缓存',
  `hidden` bit(1) DEFAULT b'0' COMMENT '隐藏',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '组件名称',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `permission` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '权限',
  `type` int(11) DEFAULT NULL COMMENT '类型',
  `sub_count` int(5) DEFAULT '0' COMMENT '子菜单数目',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`menu_id`) USING BTREE,
  UNIQUE KEY `uniq_title` (`title`),
  UNIQUE KEY `uniq_name` (`name`),
  KEY `FKqcf9gem97gqa5qjm4d3elcqt5` (`pid`) USING BTREE,
  KEY `inx_pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统菜单';

-- ----------------------------
--  Records of `sys_menu`
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES ('1', b'0', '系统管理', null, null, '1', 'system', 'system', b'0', b'0', null, '2018-12-18 15:11:29', null, '0', '6', null, null, null), ('2', b'0', '用户管理', 'system/user/index', '1', '2', 'peoples', 'user', b'0', b'0', 'User', '2018-12-18 15:14:44', 'user:list', '1', '3', null, null, null), ('3', b'0', '角色管理', 'system/role/index', '1', '3', 'role', 'role', b'0', b'0', 'Role', '2018-12-18 15:16:07', 'roles:list', '1', '3', null, null, null), ('5', b'0', '菜单管理', 'system/menu/index', '1', '5', 'menu', 'menu', b'0', b'0', 'Menu', '2018-12-18 15:17:28', 'menu:list', '1', '3', null, null, null), ('6', b'0', '系统监控', null, null, '10', 'monitor', 'monitor', b'0', b'0', null, '2018-12-18 15:17:48', null, '0', '5', null, null, null), ('7', b'0', '操作日志', 'monitor/log/index', '6', '11', 'log', 'logs', b'0', b'0', 'Log', '2018-12-18 15:18:26', null, '1', '0', null, null, null), ('9', b'0', 'SQL监控', 'monitor/sql/index', '6', '18', 'sqlMonitor', 'druid', b'0', b'0', 'Sql', '2018-12-18 15:19:34', null, '1', '0', null, null, null), ('10', b'0', '组件管理', null, null, '50', 'zujian', 'components', b'0', b'0', null, '2018-12-19 13:38:16', null, '0', '5', null, null, null), ('11', b'0', '图标库', 'components/icons/index', '10', '51', 'icon', 'icon', b'0', b'0', 'Icons', '2018-12-19 13:38:49', null, '1', '0', null, null, null), ('14', b'0', '邮件工具', 'tools/email/index', '36', '35', 'email', 'email', b'0', b'0', 'Email', '2018-12-27 10:13:09', null, '1', '0', null, null, null), ('15', b'0', '富文本', 'components/Editor', '10', '52', 'fwb', 'tinymce', b'0', b'0', 'Editor', '2018-12-27 11:58:25', null, '1', '0', null, null, null), ('16', b'0', '图床管理', 'tools/picture/index', '36', '33', 'image', 'pictures', b'0', b'0', 'Pictures', '2018-12-28 09:36:53', 'pictures:list', '1', '2', null, null, null), ('18', b'0', '存储管理', 'tools/storage/index', '36', '34', 'qiniu', 'storage', b'0', b'0', 'Storage', '2018-12-31 11:12:15', 'storage:list', '1', '3', null, null, null), ('19', b'0', '支付宝工具', 'tools/aliPay/index', '36', '37', 'alipay', 'aliPay', b'0', b'0', 'AliPay', '2018-12-31 14:52:38', null, '1', '0', null, null, null), ('21', b'0', '多级菜单', '', null, '900', 'menu', 'nested', b'0', b'1', null, '2019-01-04 16:22:03', null, '0', '2', null, null, null), ('22', b'0', '二级菜单1', 'nested/menu1/index', '21', '999', 'menu', 'menu1', b'0', b'0', null, '2019-01-04 16:23:29', null, '1', '2', null, null, null), ('23', b'0', '二级菜单2', 'nested/menu2/index', '21', '999', 'menu', 'menu2', b'0', b'0', null, '2019-01-04 16:23:57', null, '1', '0', null, null, null), ('24', b'0', '三级菜单1', 'nested/menu1/menu1-1', '22', '999', 'menu', 'menu1-1', b'0', b'0', null, '2019-01-04 16:24:48', null, '1', '0', null, null, null), ('27', b'0', '三级菜单2', 'nested/menu1/menu1-2', '22', '999', 'menu', 'menu1-2', b'0', b'0', null, '2019-01-07 17:27:32', null, '1', '0', null, null, null), ('28', b'0', '定时任务', 'system/timing/index', '36', '31', 'timing', 'timing', b'0', b'0', 'Timing', '2019-01-07 20:34:40', 'timing:list', '1', '3', null, null, null), ('30', b'0', '代码生成', 'generator/index', '36', '32', 'dev', 'generator', b'1', b'0', 'GeneratorIndex', '2019-01-11 15:45:55', null, '1', '0', null, null, null), ('32', b'0', '异常日志', 'monitor/log/errorLog', '6', '12', 'error', 'errorLog', b'0', b'0', 'ErrorLog', '2019-01-13 13:49:03', null, '1', '0', null, null, null), ('33', b'0', 'Markdown', 'components/MarkDown', '10', '53', 'markdown', 'markdown', b'0', b'0', 'Markdown', '2019-03-08 13:46:44', null, '1', '0', null, null, null), ('34', b'0', 'Yaml编辑器', 'components/YamlEdit', '10', '54', 'dev', 'yaml', b'0', b'0', 'YamlEdit', '2019-03-08 15:49:40', null, '1', '0', null, null, null), ('35', b'0', '部门管理', 'system/dept/index', '1', '6', 'dept', 'dept', b'0', b'0', 'Dept', '2019-03-25 09:46:00', 'dept:list', '1', '3', null, null, null), ('36', b'0', '系统工具', '', null, '30', 'sys-tools', 'sys-tools', b'0', b'0', null, '2019-03-29 10:57:35', null, '0', '9', null, null, null), ('37', b'0', '岗位管理', 'system/job/index', '1', '7', 'Steve-Jobs', 'job', b'0', b'0', 'Job', '2019-03-29 13:51:18', 'job:list', '1', '3', null, null, null), ('38', b'0', '接口文档', 'tools/swagger/index', '36', '36', 'swagger', 'swagger2', b'0', b'0', 'Swagger', '2019-03-29 19:57:53', null, '1', '0', null, null, null), ('39', b'0', '字典管理', 'system/dict/index', '1', '8', 'dictionary', 'dict', b'0', b'0', 'Dict', '2019-04-10 11:49:04', 'dict:list', '1', '3', null, null, null), ('41', b'0', '在线用户', 'monitor/online/index', '6', '10', 'Steve-Jobs', 'online', b'0', b'0', 'OnlineUser', '2019-10-26 22:08:43', null, '1', '0', null, null, null), ('44', b'0', '用户新增', '', '2', '2', '', '', b'0', b'0', null, '2019-10-29 10:59:46', 'user:add', '2', '0', null, null, null), ('45', b'0', '用户编辑', '', '2', '3', '', '', b'0', b'0', null, '2019-10-29 11:00:08', 'user:edit', '2', '0', null, null, null), ('46', b'0', '用户删除', '', '2', '4', '', '', b'0', b'0', null, '2019-10-29 11:00:23', 'user:del', '2', '0', null, null, null), ('48', b'0', '角色创建', '', '3', '2', '', '', b'0', b'0', null, '2019-10-29 12:45:34', 'roles:add', '2', '0', null, null, null), ('49', b'0', '角色修改', '', '3', '3', '', '', b'0', b'0', null, '2019-10-29 12:46:16', 'roles:edit', '2', '0', null, null, null), ('50', b'0', '角色删除', '', '3', '4', '', '', b'0', b'0', null, '2019-10-29 12:46:51', 'roles:del', '2', '0', null, null, null), ('52', b'0', '菜单新增', '', '5', '2', '', '', b'0', b'0', null, '2019-10-29 12:55:07', 'menu:add', '2', '0', null, null, null), ('53', b'0', '菜单编辑', '', '5', '3', '', '', b'0', b'0', null, '2019-10-29 12:55:40', 'menu:edit', '2', '0', null, null, null), ('54', b'0', '菜单删除', '', '5', '4', '', '', b'0', b'0', null, '2019-10-29 12:56:00', 'menu:del', '2', '0', null, null, null), ('56', b'0', '部门新增', '', '35', '2', '', '', b'0', b'0', null, '2019-10-29 12:57:09', 'dept:add', '2', '0', null, null, null), ('57', b'0', '部门编辑', '', '35', '3', '', '', b'0', b'0', null, '2019-10-29 12:57:27', 'dept:edit', '2', '0', null, null, null), ('58', b'0', '部门删除', '', '35', '4', '', '', b'0', b'0', null, '2019-10-29 12:57:41', 'dept:del', '2', '0', null, null, null), ('60', b'0', '岗位新增', '', '37', '2', '', '', b'0', b'0', null, '2019-10-29 12:58:27', 'job:add', '2', '0', null, null, null), ('61', b'0', '岗位编辑', '', '37', '3', '', '', b'0', b'0', null, '2019-10-29 12:58:45', 'job:edit', '2', '0', null, null, null), ('62', b'0', '岗位删除', '', '37', '4', '', '', b'0', b'0', null, '2019-10-29 12:59:04', 'job:del', '2', '0', null, null, null), ('64', b'0', '字典新增', '', '39', '2', '', '', b'0', b'0', null, '2019-10-29 13:00:17', 'dict:add', '2', '0', null, null, null), ('65', b'0', '字典编辑', '', '39', '3', '', '', b'0', b'0', null, '2019-10-29 13:00:42', 'dict:edit', '2', '0', null, null, null), ('66', b'0', '字典删除', '', '39', '4', '', '', b'0', b'0', null, '2019-10-29 13:00:59', 'dict:del', '2', '0', null, null, null), ('70', b'0', '图片上传', '', '16', '2', '', '', b'0', b'0', null, '2019-10-29 13:05:34', 'pictures:add', '2', '0', null, null, null), ('71', b'0', '图片删除', '', '16', '3', '', '', b'0', b'0', null, '2019-10-29 13:05:52', 'pictures:del', '2', '0', null, null, null), ('73', b'0', '任务新增', '', '28', '2', '', '', b'0', b'0', null, '2019-10-29 13:07:28', 'timing:add', '2', '0', null, null, null), ('74', b'0', '任务编辑', '', '28', '3', '', '', b'0', b'0', null, '2019-10-29 13:07:41', 'timing:edit', '2', '0', null, null, null), ('75', b'0', '任务删除', '', '28', '4', '', '', b'0', b'0', null, '2019-10-29 13:07:54', 'timing:del', '2', '0', null, null, null), ('77', b'0', '上传文件', '', '18', '2', '', '', b'0', b'0', null, '2019-10-29 13:09:09', 'storage:add', '2', '0', null, null, null), ('78', b'0', '文件编辑', '', '18', '3', '', '', b'0', b'0', null, '2019-10-29 13:09:22', 'storage:edit', '2', '0', null, null, null), ('79', b'0', '文件删除', '', '18', '4', '', '', b'0', b'0', null, '2019-10-29 13:09:34', 'storage:del', '2', '0', null, null, null), ('80', b'0', '服务监控', 'monitor/server/index', '6', '14', 'codeConsole', 'server', b'0', b'0', 'ServerMonitor', '2019-11-07 13:06:39', 'server:list', '1', '0', null, null, null), ('82', b'0', '生成配置', 'generator/config', '36', '33', 'dev', 'generator/config/:tableName', b'1', b'1', 'GeneratorConfig', '2019-11-17 20:08:56', '', '1', '0', null, null, null), ('83', b'0', '图表库', 'components/Echarts', '10', '50', 'chart', 'echarts', b'1', b'0', 'Echarts', '2019-11-21 09:04:32', '', '1', '0', null, null, null), ('90', b'0', '运维管理', '', null, '20', 'mnt', 'mnt', b'0', b'0', 'Mnt', '2019-11-09 10:31:08', null, '1', '5', null, null, null), ('92', b'0', '服务器', 'mnt/server/index', '90', '22', 'server', 'mnt/serverDeploy', b'0', b'0', 'ServerDeploy', '2019-11-10 10:29:25', 'serverDeploy:list', '1', '3', null, null, null), ('93', b'0', '应用管理', 'mnt/app/index', '90', '23', 'app', 'mnt/app', b'0', b'0', 'App', '2019-11-10 11:05:16', 'app:list', '1', '3', null, null, null), ('94', b'0', '部署管理', 'mnt/deploy/index', '90', '24', 'deploy', 'mnt/deploy', b'0', b'0', 'Deploy', '2019-11-10 15:56:55', 'deploy:list', '1', '3', null, null, null), ('97', b'0', '部署备份', 'mnt/deployHistory/index', '90', '25', 'backup', 'mnt/deployHistory', b'0', b'0', 'DeployHistory', '2019-11-10 16:49:44', 'deployHistory:list', '1', '1', null, null, null), ('98', b'0', '数据库管理', 'mnt/database/index', '90', '26', 'database', 'mnt/database', b'0', b'0', 'Database', '2019-11-10 20:40:04', 'database:list', '1', '3', null, null, null), ('102', b'0', '删除', '', '97', '999', '', '', b'0', b'0', null, '2019-11-17 09:32:48', 'deployHistory:del', '2', '0', null, null, null), ('103', b'0', '服务器新增', '', '92', '999', '', '', b'0', b'0', null, '2019-11-17 11:08:33', 'serverDeploy:add', '2', '0', null, null, null), ('104', b'0', '服务器编辑', '', '92', '999', '', '', b'0', b'0', null, '2019-11-17 11:08:57', 'serverDeploy:edit', '2', '0', null, null, null), ('105', b'0', '服务器删除', '', '92', '999', '', '', b'0', b'0', null, '2019-11-17 11:09:15', 'serverDeploy:del', '2', '0', null, null, null), ('106', b'0', '应用新增', '', '93', '999', '', '', b'0', b'0', null, '2019-11-17 11:10:03', 'app:add', '2', '0', null, null, null), ('107', b'0', '应用编辑', '', '93', '999', '', '', b'0', b'0', null, '2019-11-17 11:10:28', 'app:edit', '2', '0', null, null, null), ('108', b'0', '应用删除', '', '93', '999', '', '', b'0', b'0', null, '2019-11-17 11:10:55', 'app:del', '2', '0', null, null, null), ('109', b'0', '部署新增', '', '94', '999', '', '', b'0', b'0', null, '2019-11-17 11:11:22', 'deploy:add', '2', '0', null, null, null), ('110', b'0', '部署编辑', '', '94', '999', '', '', b'0', b'0', null, '2019-11-17 11:11:41', 'deploy:edit', '2', '0', null, null, null), ('111', b'0', '部署删除', '', '94', '999', '', '', b'0', b'0', null, '2019-11-17 11:12:01', 'deploy:del', '2', '0', null, null, null), ('112', b'0', '数据库新增', '', '98', '999', '', '', b'0', b'0', null, '2019-11-17 11:12:43', 'database:add', '2', '0', null, null, null), ('113', b'0', '数据库编辑', '', '98', '999', '', '', b'0', b'0', null, '2019-11-17 11:12:58', 'database:edit', '2', '0', null, null, null), ('114', b'0', '数据库删除', '', '98', '999', '', '', b'0', b'0', null, '2019-11-17 11:13:14', 'database:del', '2', '0', null, null, null), ('116', b'0', '生成预览', 'generator/preview', '36', '999', 'java', 'generator/preview/:tableName', b'1', b'1', 'Preview', '2019-11-26 14:54:36', null, '1', '0', null, null, null), ('117', b'0', '销售管理', null, null, '999', 'zujian', 'order', b'0', b'0', null, '2020-06-14 17:39:17', null, '0', '2', null, null, null), ('118', b'0', '库存一览', 'order/stock/index', '117', '1', 'zujian', 'order/stock', b'0', b'0', '库存管理', '2020-06-14 17:42:14', 'stock:list', '1', '3', null, null, null), ('119', b'0', '新增库存', null, '118', '999', null, null, b'0', b'0', null, '2020-06-14 17:46:10', 'stock:add', '2', '0', null, null, null), ('120', b'0', '修改库存', null, '118', '999', null, null, b'0', b'0', null, '2020-06-14 23:11:47', 'stock:edit', '2', '0', null, null, null), ('121', b'0', '删除库存', null, '118', '999', null, null, b'0', b'0', null, '2020-06-14 23:12:06', 'stock:del', '2', '0', null, null, null), ('122', b'0', '销售订单', 'order/bizOrder/index', '117', '999', 'list', 'api/bizOrder', b'0', b'0', '销售订单', '2020-07-25 20:04:18', 'bizOrder:list', '1', '3', null, null, null), ('123', b'0', '订单新增', null, '122', '999', null, null, b'0', b'0', null, '2020-07-25 20:08:44', 'bizOrder:add', '2', '0', null, null, null), ('124', b'0', '订单修改', null, '122', '999', null, null, b'0', b'0', null, '2020-07-25 20:09:11', 'bizOrder:edit', '2', '0', null, null, null), ('125', b'0', '订单删除', null, '122', '999', null, null, b'0', b'0', null, '2020-07-25 20:09:31', 'bizOrder:del', '2', '0', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `sys_monitor_server`
-- ----------------------------
DROP TABLE IF EXISTS `sys_monitor_server`;
CREATE TABLE `sys_monitor_server` (
  `monitor_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `cpu_core` int(11) DEFAULT NULL COMMENT 'CPU内核数',
  `cpu_rate` double DEFAULT NULL COMMENT 'CPU使用率',
  `disk_total` double DEFAULT NULL COMMENT '磁盘总量',
  `disk_used` double DEFAULT NULL COMMENT '磁盘使用量',
  `mem_total` double DEFAULT NULL COMMENT '内存总数',
  `mem_used` double DEFAULT NULL COMMENT '内存使用量',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `port` int(11) DEFAULT NULL COMMENT '访问端口',
  `monitor_sort` int(5) DEFAULT NULL COMMENT '排序',
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '状态',
  `swap_total` double DEFAULT NULL COMMENT '交换区总量',
  `swap_used` double DEFAULT NULL COMMENT '交换区使用量',
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '服务地址',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`monitor_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='服务监控';

-- ----------------------------
--  Records of `sys_monitor_server`
-- ----------------------------
BEGIN;
INSERT INTO `sys_monitor_server` VALUES ('1', '8', '0.05924018', '465.12402', '91.66521', '7.849415', '7.6052284', '本地', '8777', '999', '0', '14.599415', '11.263367', 'localhost', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `sys_quartz_job`
-- ----------------------------
DROP TABLE IF EXISTS `sys_quartz_job`;
CREATE TABLE `sys_quartz_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `bean_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Spring Bean名称',
  `cron_expression` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'cron 表达式',
  `is_pause` bit(1) DEFAULT NULL COMMENT '状态：1暂停、0启用',
  `job_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '任务名称',
  `method_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '方法名称',
  `params` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '参数',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `person_in_charge` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '负责人',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '报警邮箱',
  `sub_task` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '子任务ID',
  `pause_after_failure` bit(1) DEFAULT NULL COMMENT '任务失败后是否暂停',
  PRIMARY KEY (`job_id`) USING BTREE,
  KEY `inx_is_pause` (`is_pause`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='定时任务';

-- ----------------------------
--  Records of `sys_quartz_job`
-- ----------------------------
BEGIN;
INSERT INTO `sys_quartz_job` VALUES ('1', 'visitsTask', '0 0 0 * * ?', b'0', '更新访客记录', 'run', null, '每日0点创建新的访客记录', '2019-01-08 14:53:31', null, null, null, null, null, null, null), ('2', 'testTask', '0/5 * * * * ?', b'1', '测试1', 'run1', 'test', '带参测试，多参使用json', '2019-08-22 14:08:29', null, null, null, null, null, null, null), ('3', 'testTask', '0/5 * * * * ?', b'1', '测试', 'run', '', '不带参测试', '2019-09-26 16:44:39', null, null, null, null, null, null, null), ('4', 'restTask', '0 0 10 * * ?', b'1', '爬虫-必应每日一图', 'run', '{\"request\":{\"url\":\"http://www.bing.com/HPImageArchive.aspx?format=js&idx=0&n=1\"},\"response\":{\"baseUrl\":\"https://www.bing.com/\",\"resolvePath\":\"images->[0]->url\",\"storeTo\":\"redis\",\"storeTarget\":\"bing-image:%s\"}}', '爬虫-必应每日一图，每天10点执行', '2020-04-28 17:26:45', null, null, null, null, null, null, null), ('5', 'restTask', '0 0 10 * * ?', b'1', '爬虫-TECCHEN每日一句', 'run', '{\"request\":{\"url\":\"https://api.tecchen.tech/api/quote/history/random/\"},\"response\":{\"resolvePath\":\"data->content\",\"storeTo\":\"redis\",\"storeTarget\":\"tec-quote:%s\"}}', '爬虫-TECCHEN每日一句-TECCHEN', '2020-04-28 17:33:11', null, null, null, null, null, null, null), ('6', 'restTask', '0 0 0 * * ?', b'1', '爬虫-机器人测试', 'run', '{\"request\":{\"url\":\"https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key=57e862b3-6672-4252-af0e-cf1e90e68c7b\",\"params\":{\"msgtype\":\"markdown\",\"markdown\":{\"content\":\"| 序号 | 标题           |\\n| ---- | -------------- |\\n| 1    | 我是第一个标题 |\\n| 2    | 我是第二个呗   |\"}},\"method\":\"POST\"}}', '爬虫-机器人测试', '2020-04-28 18:00:20', null, null, null, null, null, null, null), ('7', 'restTask', '0 0 10 * * ?', b'0', '爬虫-shanbay每日一句', 'run', '{\"request\":{\"url\":\"https://rest.shanbay.com/api/v2/quote/quotes/today/\"},\"response\":{\"resolvePath\":\"data->content\",\n\"storeTo\":\"redis\",\"storeTarget\":\"shanbay-quote:%s\"}}', '爬虫--shanbay每日一句', '2020-04-28 18:25:58', null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `sys_quartz_log`
-- ----------------------------
DROP TABLE IF EXISTS `sys_quartz_log`;
CREATE TABLE `sys_quartz_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `bean_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Bean 名称',
  `create_time` datetime DEFAULT NULL,
  `cron_expression` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exception_detail` text COLLATE utf8mb4_unicode_ci,
  `is_success` bit(1) DEFAULT NULL,
  `job_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `params` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time` bigint(20) DEFAULT NULL,
  `result` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`log_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='定时任务日志';

-- ----------------------------
--  Table structure for `sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `data_scope` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '数据权限',
  `level` int(255) DEFAULT NULL COMMENT '角色级别',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`role_id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色表';

-- ----------------------------
--  Records of `sys_role`
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('1', '超级管理员', '-', '全部', '1', '2018-11-23 11:04:37', null, null, null), ('2', '普通用户', '-', '本级', '2', '2018-11-23 13:09:06', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `sys_roles_depts`
-- ----------------------------
DROP TABLE IF EXISTS `sys_roles_depts`;
CREATE TABLE `sys_roles_depts` (
  `role_id` bigint(20) NOT NULL,
  `dept_id` bigint(20) NOT NULL,
  PRIMARY KEY (`role_id`,`dept_id`) USING BTREE,
  KEY `FK7qg6itn5ajdoa9h9o78v9ksur` (`dept_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色部门关联';

-- ----------------------------
--  Table structure for `sys_roles_menus`
-- ----------------------------
DROP TABLE IF EXISTS `sys_roles_menus`;
CREATE TABLE `sys_roles_menus` (
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`menu_id`,`role_id`) USING BTREE,
  KEY `FKcngg2qadojhi3a651a5adkvbq` (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色菜单关联';

-- ----------------------------
--  Records of `sys_roles_menus`
-- ----------------------------
BEGIN;
INSERT INTO `sys_roles_menus` VALUES ('1', '1'), ('2', '1'), ('3', '1'), ('5', '1'), ('6', '1'), ('7', '1'), ('9', '1'), ('10', '1'), ('11', '1'), ('14', '1'), ('15', '1'), ('16', '1'), ('18', '1'), ('19', '1'), ('21', '1'), ('22', '1'), ('23', '1'), ('24', '1'), ('27', '1'), ('28', '1'), ('30', '1'), ('32', '1'), ('33', '1'), ('34', '1'), ('35', '1'), ('36', '1'), ('37', '1'), ('38', '1'), ('39', '1'), ('41', '1'), ('44', '1'), ('45', '1'), ('46', '1'), ('48', '1'), ('49', '1'), ('50', '1'), ('52', '1'), ('53', '1'), ('54', '1'), ('56', '1'), ('57', '1'), ('58', '1'), ('60', '1'), ('61', '1'), ('62', '1'), ('64', '1'), ('65', '1'), ('66', '1'), ('73', '1'), ('74', '1'), ('75', '1'), ('77', '1'), ('78', '1'), ('79', '1'), ('80', '1'), ('82', '1'), ('83', '1'), ('90', '1'), ('92', '1'), ('93', '1'), ('94', '1'), ('97', '1'), ('98', '1'), ('116', '1'), ('117', '1'), ('118', '1'), ('119', '1'), ('120', '1'), ('121', '1'), ('122', '1'), ('123', '1'), ('124', '1'), ('125', '1'), ('1', '2'), ('2', '2'), ('3', '2'), ('5', '2'), ('6', '2'), ('9', '2'), ('10', '2'), ('11', '2'), ('14', '2'), ('15', '2'), ('18', '2'), ('19', '2'), ('21', '2'), ('23', '2'), ('24', '2'), ('27', '2'), ('28', '2'), ('30', '2'), ('33', '2'), ('34', '2'), ('35', '2'), ('36', '2'), ('37', '2'), ('38', '2'), ('39', '2'), ('44', '2'), ('48', '2'), ('49', '2'), ('50', '2'), ('77', '2'), ('78', '2'), ('79', '2'), ('117', '2'), ('118', '2'), ('119', '2'), ('120', '2'), ('121', '2'), ('122', '2'), ('123', '2'), ('124', '2'), ('125', '2');
COMMIT;

-- ----------------------------
--  Table structure for `sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `avatar_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像地址',
  `avatar_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像真实路径',
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
  `enabled` bigint(20) DEFAULT NULL COMMENT '状态：1启用、0禁用',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户名',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门名称',
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号码',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `is_admin` bit(1) DEFAULT b'0' COMMENT '是否为admin账号',
  `pwd_reset_time` datetime DEFAULT NULL COMMENT '修改密码的时间',
  `nick_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '性别',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `UK_kpubos9gc2cvtkb0thktkbkes` (`email`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE,
  UNIQUE KEY `uniq_username` (`username`),
  UNIQUE KEY `uniq_email` (`email`),
  KEY `FK5rwmryny6jthaaxkogownknqp` (`dept_id`) USING BTREE,
  KEY `FKpq2dhypk2qgt68nauh2by22jb` (`avatar_url`) USING BTREE,
  KEY `inx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统用户';

-- ----------------------------
--  Records of `sys_user`
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('1', null, null, 'zhengjie@tom.com', '1', null, null, '$2a$10$fP.426qKaTmix50Oln8L.uav55gELhAd0Eg66Av4oG86u8km7D/Ky', 'admin', '2', '18888888888', '2018-08-23 09:11:56', b'1', '2019-05-18 17:34:21', '管理员', '男', null);
COMMIT;

-- ----------------------------
--  Table structure for `sys_users_jobs`
-- ----------------------------
DROP TABLE IF EXISTS `sys_users_jobs`;
CREATE TABLE `sys_users_jobs` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `job_id` bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`,`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `sys_users_roles`
-- ----------------------------
DROP TABLE IF EXISTS `sys_users_roles`;
CREATE TABLE `sys_users_roles` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`) USING BTREE,
  KEY `FKq4eq273l04bpu4efj0jd0jb98` (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户角色关联';

-- ----------------------------
--  Records of `sys_users_roles`
-- ----------------------------
BEGIN;
INSERT INTO `sys_users_roles` VALUES ('1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `sys_verification_code`
-- ----------------------------
DROP TABLE IF EXISTS `sys_verification_code`;
CREATE TABLE `sys_verification_code` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '验证码',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `status` bit(1) DEFAULT NULL COMMENT '状态：1有效、0过期',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '验证码类型：email或者短信',
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '接收邮箱或者手机号码',
  `scenes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '业务名称：如重置邮箱、重置密码等',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='验证码';

-- ----------------------------
--  Table structure for `sys_visits`
-- ----------------------------
DROP TABLE IF EXISTS `sys_visits`;
CREATE TABLE `sys_visits` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_counts` bigint(20) DEFAULT NULL,
  `pv_counts` bigint(20) DEFAULT NULL,
  `week_day` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_11aksgq87euk9bcyeesfs4vtp` (`date`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='访客记录';

-- ----------------------------
--  Table structure for `tool_alipay_config`
-- ----------------------------
DROP TABLE IF EXISTS `tool_alipay_config`;
CREATE TABLE `tool_alipay_config` (
  `config_id` bigint(20) NOT NULL COMMENT 'ID',
  `app_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用ID',
  `charset` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '编码',
  `format` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型 固定格式json',
  `gateway_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '网关地址',
  `notify_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '异步回调',
  `private_key` text COLLATE utf8mb4_unicode_ci COMMENT '私钥',
  `public_key` text COLLATE utf8mb4_unicode_ci COMMENT '公钥',
  `return_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '回调地址',
  `sign_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '签名方式',
  `sys_service_provider_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商户号',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='支付宝配置类';

-- ----------------------------
--  Table structure for `tool_email_config`
-- ----------------------------
DROP TABLE IF EXISTS `tool_email_config`;
CREATE TABLE `tool_email_config` (
  `config_id` bigint(20) NOT NULL COMMENT 'ID',
  `from_user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收件人',
  `host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮件服务器SMTP地址',
  `pass` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
  `port` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '端口',
  `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发件者用户名',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='邮箱配置';

-- ----------------------------
--  Table structure for `tool_local_storage`
-- ----------------------------
DROP TABLE IF EXISTS `tool_local_storage`;
CREATE TABLE `tool_local_storage` (
  `storage_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `real_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件真实的名称',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名',
  `suffix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '后缀',
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '路径',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型',
  `size` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '大小',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`storage_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='本地存储';

-- ----------------------------
--  Table structure for `tool_picture`
-- ----------------------------
DROP TABLE IF EXISTS `tool_picture`;
CREATE TABLE `tool_picture` (
  `picture_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `create_time` datetime DEFAULT NULL COMMENT '上传日期',
  `delete_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '删除的URL',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片名称',
  `height` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片高度',
  `size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片大小',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片地址',
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户名称',
  `width` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片宽度',
  `md5code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件的MD5值',
  PRIMARY KEY (`picture_id`) USING BTREE,
  UNIQUE KEY `uniq_md5_code` (`md5code`),
  KEY `inx_url` (`url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Sm.Ms图床';

-- ----------------------------
--  Table structure for `tool_qiniu_config`
-- ----------------------------
DROP TABLE IF EXISTS `tool_qiniu_config`;
CREATE TABLE `tool_qiniu_config` (
  `config_id` bigint(20) NOT NULL COMMENT 'ID',
  `access_key` text COLLATE utf8mb4_unicode_ci COMMENT 'accessKey',
  `bucket` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Bucket 识别符',
  `host` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '外链域名',
  `secret_key` text COLLATE utf8mb4_unicode_ci COMMENT 'secretKey',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '空间类型',
  `zone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '机房',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='七牛云配置';

-- ----------------------------
--  Table structure for `tool_qiniu_content`
-- ----------------------------
DROP TABLE IF EXISTS `tool_qiniu_content`;
CREATE TABLE `tool_qiniu_content` (
  `content_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `bucket` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Bucket 识别符',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名称',
  `size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件大小',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件类型：私有或公开',
  `update_time` datetime DEFAULT NULL COMMENT '上传或同步的时间',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件url',
  `suffix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`content_id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='七牛云文件存储';

SET FOREIGN_KEY_CHECKS = 1;
